package com.ssish.saas.eccs.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CardExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CardExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCardNoIsNull() {
            addCriterion("CARD_NO is null");
            return (Criteria) this;
        }

        public Criteria andCardNoIsNotNull() {
            addCriterion("CARD_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoEqualTo(BigDecimal value) {
            addCriterion("CARD_NO =", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotEqualTo(BigDecimal value) {
            addCriterion("CARD_NO <>", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThan(BigDecimal value) {
            addCriterion("CARD_NO >", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARD_NO >=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThan(BigDecimal value) {
            addCriterion("CARD_NO <", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARD_NO <=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoIn(List<BigDecimal> values) {
            addCriterion("CARD_NO in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotIn(List<BigDecimal> values) {
            addCriterion("CARD_NO not in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARD_NO between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARD_NO not between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andRecordTypeIsNull() {
            addCriterion("RECORD_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andRecordTypeIsNotNull() {
            addCriterion("RECORD_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTypeEqualTo(String value) {
            addCriterion("RECORD_TYPE =", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotEqualTo(String value) {
            addCriterion("RECORD_TYPE <>", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeGreaterThan(String value) {
            addCriterion("RECORD_TYPE >", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeGreaterThanOrEqualTo(String value) {
            addCriterion("RECORD_TYPE >=", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeLessThan(String value) {
            addCriterion("RECORD_TYPE <", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeLessThanOrEqualTo(String value) {
            addCriterion("RECORD_TYPE <=", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeLike(String value) {
            addCriterion("RECORD_TYPE like", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotLike(String value) {
            addCriterion("RECORD_TYPE not like", value, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeIn(List<String> values) {
            addCriterion("RECORD_TYPE in", values, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotIn(List<String> values) {
            addCriterion("RECORD_TYPE not in", values, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeBetween(String value1, String value2) {
            addCriterion("RECORD_TYPE between", value1, value2, "recordType");
            return (Criteria) this;
        }

        public Criteria andRecordTypeNotBetween(String value1, String value2) {
            addCriterion("RECORD_TYPE not between", value1, value2, "recordType");
            return (Criteria) this;
        }

        public Criteria andBatchNoIsNull() {
            addCriterion("BATCH_NO is null");
            return (Criteria) this;
        }

        public Criteria andBatchNoIsNotNull() {
            addCriterion("BATCH_NO is not null");
            return (Criteria) this;
        }

        public Criteria andBatchNoEqualTo(Integer value) {
            addCriterion("BATCH_NO =", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoNotEqualTo(Integer value) {
            addCriterion("BATCH_NO <>", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoGreaterThan(Integer value) {
            addCriterion("BATCH_NO >", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("BATCH_NO >=", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoLessThan(Integer value) {
            addCriterion("BATCH_NO <", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoLessThanOrEqualTo(Integer value) {
            addCriterion("BATCH_NO <=", value, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoIn(List<Integer> values) {
            addCriterion("BATCH_NO in", values, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoNotIn(List<Integer> values) {
            addCriterion("BATCH_NO not in", values, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoBetween(Integer value1, Integer value2) {
            addCriterion("BATCH_NO between", value1, value2, "batchNo");
            return (Criteria) this;
        }

        public Criteria andBatchNoNotBetween(Integer value1, Integer value2) {
            addCriterion("BATCH_NO not between", value1, value2, "batchNo");
            return (Criteria) this;
        }

        public Criteria andPincodeIsNull() {
            addCriterion("PINCODE is null");
            return (Criteria) this;
        }

        public Criteria andPincodeIsNotNull() {
            addCriterion("PINCODE is not null");
            return (Criteria) this;
        }

        public Criteria andPincodeEqualTo(Integer value) {
            addCriterion("PINCODE =", value, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeNotEqualTo(Integer value) {
            addCriterion("PINCODE <>", value, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeGreaterThan(Integer value) {
            addCriterion("PINCODE >", value, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("PINCODE >=", value, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeLessThan(Integer value) {
            addCriterion("PINCODE <", value, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeLessThanOrEqualTo(Integer value) {
            addCriterion("PINCODE <=", value, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeIn(List<Integer> values) {
            addCriterion("PINCODE in", values, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeNotIn(List<Integer> values) {
            addCriterion("PINCODE not in", values, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeBetween(Integer value1, Integer value2) {
            addCriterion("PINCODE between", value1, value2, "pincode");
            return (Criteria) this;
        }

        public Criteria andPincodeNotBetween(Integer value1, Integer value2) {
            addCriterion("PINCODE not between", value1, value2, "pincode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNull() {
            addCriterion("USER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andUserCodeIsNotNull() {
            addCriterion("USER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andUserCodeEqualTo(String value) {
            addCriterion("USER_CODE =", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotEqualTo(String value) {
            addCriterion("USER_CODE <>", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThan(String value) {
            addCriterion("USER_CODE >", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeGreaterThanOrEqualTo(String value) {
            addCriterion("USER_CODE >=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThan(String value) {
            addCriterion("USER_CODE <", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLessThanOrEqualTo(String value) {
            addCriterion("USER_CODE <=", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeLike(String value) {
            addCriterion("USER_CODE like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotLike(String value) {
            addCriterion("USER_CODE not like", value, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeIn(List<String> values) {
            addCriterion("USER_CODE in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotIn(List<String> values) {
            addCriterion("USER_CODE not in", values, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeBetween(String value1, String value2) {
            addCriterion("USER_CODE between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andUserCodeNotBetween(String value1, String value2) {
            addCriterion("USER_CODE not between", value1, value2, "userCode");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andAmountPaidIsNull() {
            addCriterion("AMOUNT_PAID is null");
            return (Criteria) this;
        }

        public Criteria andAmountPaidIsNotNull() {
            addCriterion("AMOUNT_PAID is not null");
            return (Criteria) this;
        }

        public Criteria andAmountPaidEqualTo(BigDecimal value) {
            addCriterion("AMOUNT_PAID =", value, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidNotEqualTo(BigDecimal value) {
            addCriterion("AMOUNT_PAID <>", value, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidGreaterThan(BigDecimal value) {
            addCriterion("AMOUNT_PAID >", value, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AMOUNT_PAID >=", value, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidLessThan(BigDecimal value) {
            addCriterion("AMOUNT_PAID <", value, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AMOUNT_PAID <=", value, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidIn(List<BigDecimal> values) {
            addCriterion("AMOUNT_PAID in", values, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidNotIn(List<BigDecimal> values) {
            addCriterion("AMOUNT_PAID not in", values, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AMOUNT_PAID between", value1, value2, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andAmountPaidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AMOUNT_PAID not between", value1, value2, "amountPaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidIsNull() {
            addCriterion("DATE_PAID is null");
            return (Criteria) this;
        }

        public Criteria andDatePaidIsNotNull() {
            addCriterion("DATE_PAID is not null");
            return (Criteria) this;
        }

        public Criteria andDatePaidEqualTo(Date value) {
            addCriterion("DATE_PAID =", value, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidNotEqualTo(Date value) {
            addCriterion("DATE_PAID <>", value, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidGreaterThan(Date value) {
            addCriterion("DATE_PAID >", value, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidGreaterThanOrEqualTo(Date value) {
            addCriterion("DATE_PAID >=", value, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidLessThan(Date value) {
            addCriterion("DATE_PAID <", value, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidLessThanOrEqualTo(Date value) {
            addCriterion("DATE_PAID <=", value, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidIn(List<Date> values) {
            addCriterion("DATE_PAID in", values, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidNotIn(List<Date> values) {
            addCriterion("DATE_PAID not in", values, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidBetween(Date value1, Date value2) {
            addCriterion("DATE_PAID between", value1, value2, "datePaid");
            return (Criteria) this;
        }

        public Criteria andDatePaidNotBetween(Date value1, Date value2) {
            addCriterion("DATE_PAID not between", value1, value2, "datePaid");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIsNull() {
            addCriterion("EXPIRY_DATE is null");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIsNotNull() {
            addCriterion("EXPIRY_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andExpiryDateEqualTo(Date value) {
            addCriterion("EXPIRY_DATE =", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotEqualTo(Date value) {
            addCriterion("EXPIRY_DATE <>", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateGreaterThan(Date value) {
            addCriterion("EXPIRY_DATE >", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateGreaterThanOrEqualTo(Date value) {
            addCriterion("EXPIRY_DATE >=", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLessThan(Date value) {
            addCriterion("EXPIRY_DATE <", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateLessThanOrEqualTo(Date value) {
            addCriterion("EXPIRY_DATE <=", value, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateIn(List<Date> values) {
            addCriterion("EXPIRY_DATE in", values, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotIn(List<Date> values) {
            addCriterion("EXPIRY_DATE not in", values, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateBetween(Date value1, Date value2) {
            addCriterion("EXPIRY_DATE between", value1, value2, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andExpiryDateNotBetween(Date value1, Date value2) {
            addCriterion("EXPIRY_DATE not between", value1, value2, "expiryDate");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoIsNull() {
            addCriterion("SUBSCRIBER_ACCT_NO is null");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoIsNotNull() {
            addCriterion("SUBSCRIBER_ACCT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoEqualTo(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO =", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoNotEqualTo(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO <>", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoGreaterThan(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO >", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoGreaterThanOrEqualTo(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO >=", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoLessThan(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO <", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoLessThanOrEqualTo(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO <=", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoLike(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO like", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoNotLike(String value) {
            addCriterion("SUBSCRIBER_ACCT_NO not like", value, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoIn(List<String> values) {
            addCriterion("SUBSCRIBER_ACCT_NO in", values, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoNotIn(List<String> values) {
            addCriterion("SUBSCRIBER_ACCT_NO not in", values, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoBetween(String value1, String value2) {
            addCriterion("SUBSCRIBER_ACCT_NO between", value1, value2, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubscriberAcctNoNotBetween(String value1, String value2) {
            addCriterion("SUBSCRIBER_ACCT_NO not between", value1, value2, "subscriberAcctNo");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountIsNull() {
            addCriterion("TYPE_OF_ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountIsNotNull() {
            addCriterion("TYPE_OF_ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountEqualTo(Long value) {
            addCriterion("TYPE_OF_ACCOUNT =", value, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountNotEqualTo(Long value) {
            addCriterion("TYPE_OF_ACCOUNT <>", value, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountGreaterThan(Long value) {
            addCriterion("TYPE_OF_ACCOUNT >", value, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountGreaterThanOrEqualTo(Long value) {
            addCriterion("TYPE_OF_ACCOUNT >=", value, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountLessThan(Long value) {
            addCriterion("TYPE_OF_ACCOUNT <", value, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountLessThanOrEqualTo(Long value) {
            addCriterion("TYPE_OF_ACCOUNT <=", value, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountIn(List<Long> values) {
            addCriterion("TYPE_OF_ACCOUNT in", values, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountNotIn(List<Long> values) {
            addCriterion("TYPE_OF_ACCOUNT not in", values, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountBetween(Long value1, Long value2) {
            addCriterion("TYPE_OF_ACCOUNT between", value1, value2, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfAccountNotBetween(Long value1, Long value2) {
            addCriterion("TYPE_OF_ACCOUNT not between", value1, value2, "typeOfAccount");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardIsNull() {
            addCriterion("TYPE_OF_CREDIT_CARD is null");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardIsNotNull() {
            addCriterion("TYPE_OF_CREDIT_CARD is not null");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardEqualTo(Long value) {
            addCriterion("TYPE_OF_CREDIT_CARD =", value, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardNotEqualTo(Long value) {
            addCriterion("TYPE_OF_CREDIT_CARD <>", value, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardGreaterThan(Long value) {
            addCriterion("TYPE_OF_CREDIT_CARD >", value, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardGreaterThanOrEqualTo(Long value) {
            addCriterion("TYPE_OF_CREDIT_CARD >=", value, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardLessThan(Long value) {
            addCriterion("TYPE_OF_CREDIT_CARD <", value, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardLessThanOrEqualTo(Long value) {
            addCriterion("TYPE_OF_CREDIT_CARD <=", value, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardIn(List<Long> values) {
            addCriterion("TYPE_OF_CREDIT_CARD in", values, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardNotIn(List<Long> values) {
            addCriterion("TYPE_OF_CREDIT_CARD not in", values, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardBetween(Long value1, Long value2) {
            addCriterion("TYPE_OF_CREDIT_CARD between", value1, value2, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andTypeOfCreditCardNotBetween(Long value1, Long value2) {
            addCriterion("TYPE_OF_CREDIT_CARD not between", value1, value2, "typeOfCreditCard");
            return (Criteria) this;
        }

        public Criteria andUsageIsNull() {
            addCriterion("USAGE is null");
            return (Criteria) this;
        }

        public Criteria andUsageIsNotNull() {
            addCriterion("USAGE is not null");
            return (Criteria) this;
        }

        public Criteria andUsageEqualTo(Short value) {
            addCriterion("USAGE =", value, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageNotEqualTo(Short value) {
            addCriterion("USAGE <>", value, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageGreaterThan(Short value) {
            addCriterion("USAGE >", value, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageGreaterThanOrEqualTo(Short value) {
            addCriterion("USAGE >=", value, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageLessThan(Short value) {
            addCriterion("USAGE <", value, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageLessThanOrEqualTo(Short value) {
            addCriterion("USAGE <=", value, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageIn(List<Short> values) {
            addCriterion("USAGE in", values, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageNotIn(List<Short> values) {
            addCriterion("USAGE not in", values, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageBetween(Short value1, Short value2) {
            addCriterion("USAGE between", value1, value2, "usage");
            return (Criteria) this;
        }

        public Criteria andUsageNotBetween(Short value1, Short value2) {
            addCriterion("USAGE not between", value1, value2, "usage");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNull() {
            addCriterion("ACTIVE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIsNotNull() {
            addCriterion("ACTIVE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andActiveFlagEqualTo(String value) {
            addCriterion("ACTIVE_FLAG =", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <>", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThan(String value) {
            addCriterion("ACTIVE_FLAG >", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagGreaterThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG >=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThan(String value) {
            addCriterion("ACTIVE_FLAG <", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLessThanOrEqualTo(String value) {
            addCriterion("ACTIVE_FLAG <=", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagLike(String value) {
            addCriterion("ACTIVE_FLAG like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotLike(String value) {
            addCriterion("ACTIVE_FLAG not like", value, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagIn(List<String> values) {
            addCriterion("ACTIVE_FLAG in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotIn(List<String> values) {
            addCriterion("ACTIVE_FLAG not in", values, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andActiveFlagNotBetween(String value1, String value2) {
            addCriterion("ACTIVE_FLAG not between", value1, value2, "activeFlag");
            return (Criteria) this;
        }

        public Criteria andCardNoBinIsNull() {
            addCriterion("CARD_NO_BIN is null");
            return (Criteria) this;
        }

        public Criteria andCardNoBinIsNotNull() {
            addCriterion("CARD_NO_BIN is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoBinEqualTo(Integer value) {
            addCriterion("CARD_NO_BIN =", value, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinNotEqualTo(Integer value) {
            addCriterion("CARD_NO_BIN <>", value, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinGreaterThan(Integer value) {
            addCriterion("CARD_NO_BIN >", value, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinGreaterThanOrEqualTo(Integer value) {
            addCriterion("CARD_NO_BIN >=", value, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinLessThan(Integer value) {
            addCriterion("CARD_NO_BIN <", value, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinLessThanOrEqualTo(Integer value) {
            addCriterion("CARD_NO_BIN <=", value, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinIn(List<Integer> values) {
            addCriterion("CARD_NO_BIN in", values, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinNotIn(List<Integer> values) {
            addCriterion("CARD_NO_BIN not in", values, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinBetween(Integer value1, Integer value2) {
            addCriterion("CARD_NO_BIN between", value1, value2, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoBinNotBetween(Integer value1, Integer value2) {
            addCriterion("CARD_NO_BIN not between", value1, value2, "cardNoBin");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdIsNull() {
            addCriterion("CARD_NO_PAYOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdIsNotNull() {
            addCriterion("CARD_NO_PAYOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdEqualTo(Short value) {
            addCriterion("CARD_NO_PAYOR_ID =", value, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdNotEqualTo(Short value) {
            addCriterion("CARD_NO_PAYOR_ID <>", value, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdGreaterThan(Short value) {
            addCriterion("CARD_NO_PAYOR_ID >", value, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdGreaterThanOrEqualTo(Short value) {
            addCriterion("CARD_NO_PAYOR_ID >=", value, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdLessThan(Short value) {
            addCriterion("CARD_NO_PAYOR_ID <", value, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdLessThanOrEqualTo(Short value) {
            addCriterion("CARD_NO_PAYOR_ID <=", value, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdIn(List<Short> values) {
            addCriterion("CARD_NO_PAYOR_ID in", values, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdNotIn(List<Short> values) {
            addCriterion("CARD_NO_PAYOR_ID not in", values, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdBetween(Short value1, Short value2) {
            addCriterion("CARD_NO_PAYOR_ID between", value1, value2, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPayorIdNotBetween(Short value1, Short value2) {
            addCriterion("CARD_NO_PAYOR_ID not between", value1, value2, "cardNoPayorId");
            return (Criteria) this;
        }

        public Criteria andCardNoPisIsNull() {
            addCriterion("CARD_NO_PIS is null");
            return (Criteria) this;
        }

        public Criteria andCardNoPisIsNotNull() {
            addCriterion("CARD_NO_PIS is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoPisEqualTo(String value) {
            addCriterion("CARD_NO_PIS =", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisNotEqualTo(String value) {
            addCriterion("CARD_NO_PIS <>", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisGreaterThan(String value) {
            addCriterion("CARD_NO_PIS >", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_NO_PIS >=", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisLessThan(String value) {
            addCriterion("CARD_NO_PIS <", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisLessThanOrEqualTo(String value) {
            addCriterion("CARD_NO_PIS <=", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisLike(String value) {
            addCriterion("CARD_NO_PIS like", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisNotLike(String value) {
            addCriterion("CARD_NO_PIS not like", value, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisIn(List<String> values) {
            addCriterion("CARD_NO_PIS in", values, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisNotIn(List<String> values) {
            addCriterion("CARD_NO_PIS not in", values, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisBetween(String value1, String value2) {
            addCriterion("CARD_NO_PIS between", value1, value2, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoPisNotBetween(String value1, String value2) {
            addCriterion("CARD_NO_PIS not between", value1, value2, "cardNoPis");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqIsNull() {
            addCriterion("CARD_NO_SEQ is null");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqIsNotNull() {
            addCriterion("CARD_NO_SEQ is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqEqualTo(Long value) {
            addCriterion("CARD_NO_SEQ =", value, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqNotEqualTo(Long value) {
            addCriterion("CARD_NO_SEQ <>", value, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqGreaterThan(Long value) {
            addCriterion("CARD_NO_SEQ >", value, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqGreaterThanOrEqualTo(Long value) {
            addCriterion("CARD_NO_SEQ >=", value, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqLessThan(Long value) {
            addCriterion("CARD_NO_SEQ <", value, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqLessThanOrEqualTo(Long value) {
            addCriterion("CARD_NO_SEQ <=", value, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqIn(List<Long> values) {
            addCriterion("CARD_NO_SEQ in", values, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqNotIn(List<Long> values) {
            addCriterion("CARD_NO_SEQ not in", values, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqBetween(Long value1, Long value2) {
            addCriterion("CARD_NO_SEQ between", value1, value2, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCardNoSeqNotBetween(Long value1, Long value2) {
            addCriterion("CARD_NO_SEQ not between", value1, value2, "cardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinIsNull() {
            addCriterion("CREDIT_CARD_BIN is null");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinIsNotNull() {
            addCriterion("CREDIT_CARD_BIN is not null");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinEqualTo(Integer value) {
            addCriterion("CREDIT_CARD_BIN =", value, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinNotEqualTo(Integer value) {
            addCriterion("CREDIT_CARD_BIN <>", value, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinGreaterThan(Integer value) {
            addCriterion("CREDIT_CARD_BIN >", value, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinGreaterThanOrEqualTo(Integer value) {
            addCriterion("CREDIT_CARD_BIN >=", value, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinLessThan(Integer value) {
            addCriterion("CREDIT_CARD_BIN <", value, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinLessThanOrEqualTo(Integer value) {
            addCriterion("CREDIT_CARD_BIN <=", value, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinIn(List<Integer> values) {
            addCriterion("CREDIT_CARD_BIN in", values, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinNotIn(List<Integer> values) {
            addCriterion("CREDIT_CARD_BIN not in", values, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinBetween(Integer value1, Integer value2) {
            addCriterion("CREDIT_CARD_BIN between", value1, value2, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardBinNotBetween(Integer value1, Integer value2) {
            addCriterion("CREDIT_CARD_BIN not between", value1, value2, "creditCardBin");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoIsNull() {
            addCriterion("CREDIT_CARD_NO is null");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoIsNotNull() {
            addCriterion("CREDIT_CARD_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoEqualTo(String value) {
            addCriterion("CREDIT_CARD_NO =", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoNotEqualTo(String value) {
            addCriterion("CREDIT_CARD_NO <>", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoGreaterThan(String value) {
            addCriterion("CREDIT_CARD_NO >", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoGreaterThanOrEqualTo(String value) {
            addCriterion("CREDIT_CARD_NO >=", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoLessThan(String value) {
            addCriterion("CREDIT_CARD_NO <", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoLessThanOrEqualTo(String value) {
            addCriterion("CREDIT_CARD_NO <=", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoLike(String value) {
            addCriterion("CREDIT_CARD_NO like", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoNotLike(String value) {
            addCriterion("CREDIT_CARD_NO not like", value, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoIn(List<String> values) {
            addCriterion("CREDIT_CARD_NO in", values, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoNotIn(List<String> values) {
            addCriterion("CREDIT_CARD_NO not in", values, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoBetween(String value1, String value2) {
            addCriterion("CREDIT_CARD_NO between", value1, value2, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoNotBetween(String value1, String value2) {
            addCriterion("CREDIT_CARD_NO not between", value1, value2, "creditCardNo");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqIsNull() {
            addCriterion("CREDIT_CARD_NO_SEQ is null");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqIsNotNull() {
            addCriterion("CREDIT_CARD_NO_SEQ is not null");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqEqualTo(Long value) {
            addCriterion("CREDIT_CARD_NO_SEQ =", value, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqNotEqualTo(Long value) {
            addCriterion("CREDIT_CARD_NO_SEQ <>", value, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqGreaterThan(Long value) {
            addCriterion("CREDIT_CARD_NO_SEQ >", value, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqGreaterThanOrEqualTo(Long value) {
            addCriterion("CREDIT_CARD_NO_SEQ >=", value, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqLessThan(Long value) {
            addCriterion("CREDIT_CARD_NO_SEQ <", value, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqLessThanOrEqualTo(Long value) {
            addCriterion("CREDIT_CARD_NO_SEQ <=", value, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqIn(List<Long> values) {
            addCriterion("CREDIT_CARD_NO_SEQ in", values, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqNotIn(List<Long> values) {
            addCriterion("CREDIT_CARD_NO_SEQ not in", values, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqBetween(Long value1, Long value2) {
            addCriterion("CREDIT_CARD_NO_SEQ between", value1, value2, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andCreditCardNoSeqNotBetween(Long value1, Long value2) {
            addCriterion("CREDIT_CARD_NO_SEQ not between", value1, value2, "creditCardNoSeq");
            return (Criteria) this;
        }

        public Criteria andDependentIdIsNull() {
            addCriterion("DEPENDENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andDependentIdIsNotNull() {
            addCriterion("DEPENDENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDependentIdEqualTo(String value) {
            addCriterion("DEPENDENT_ID =", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotEqualTo(String value) {
            addCriterion("DEPENDENT_ID <>", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdGreaterThan(String value) {
            addCriterion("DEPENDENT_ID >", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdGreaterThanOrEqualTo(String value) {
            addCriterion("DEPENDENT_ID >=", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdLessThan(String value) {
            addCriterion("DEPENDENT_ID <", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdLessThanOrEqualTo(String value) {
            addCriterion("DEPENDENT_ID <=", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdLike(String value) {
            addCriterion("DEPENDENT_ID like", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotLike(String value) {
            addCriterion("DEPENDENT_ID not like", value, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdIn(List<String> values) {
            addCriterion("DEPENDENT_ID in", values, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotIn(List<String> values) {
            addCriterion("DEPENDENT_ID not in", values, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdBetween(String value1, String value2) {
            addCriterion("DEPENDENT_ID between", value1, value2, "dependentId");
            return (Criteria) this;
        }

        public Criteria andDependentIdNotBetween(String value1, String value2) {
            addCriterion("DEPENDENT_ID not between", value1, value2, "dependentId");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthIsNull() {
            addCriterion("EXPIRY_MONTH is null");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthIsNotNull() {
            addCriterion("EXPIRY_MONTH is not null");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthEqualTo(String value) {
            addCriterion("EXPIRY_MONTH =", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthNotEqualTo(String value) {
            addCriterion("EXPIRY_MONTH <>", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthGreaterThan(String value) {
            addCriterion("EXPIRY_MONTH >", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthGreaterThanOrEqualTo(String value) {
            addCriterion("EXPIRY_MONTH >=", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthLessThan(String value) {
            addCriterion("EXPIRY_MONTH <", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthLessThanOrEqualTo(String value) {
            addCriterion("EXPIRY_MONTH <=", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthLike(String value) {
            addCriterion("EXPIRY_MONTH like", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthNotLike(String value) {
            addCriterion("EXPIRY_MONTH not like", value, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthIn(List<String> values) {
            addCriterion("EXPIRY_MONTH in", values, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthNotIn(List<String> values) {
            addCriterion("EXPIRY_MONTH not in", values, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthBetween(String value1, String value2) {
            addCriterion("EXPIRY_MONTH between", value1, value2, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryMonthNotBetween(String value1, String value2) {
            addCriterion("EXPIRY_MONTH not between", value1, value2, "expiryMonth");
            return (Criteria) this;
        }

        public Criteria andExpiryYearIsNull() {
            addCriterion("EXPIRY_YEAR is null");
            return (Criteria) this;
        }

        public Criteria andExpiryYearIsNotNull() {
            addCriterion("EXPIRY_YEAR is not null");
            return (Criteria) this;
        }

        public Criteria andExpiryYearEqualTo(String value) {
            addCriterion("EXPIRY_YEAR =", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearNotEqualTo(String value) {
            addCriterion("EXPIRY_YEAR <>", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearGreaterThan(String value) {
            addCriterion("EXPIRY_YEAR >", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearGreaterThanOrEqualTo(String value) {
            addCriterion("EXPIRY_YEAR >=", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearLessThan(String value) {
            addCriterion("EXPIRY_YEAR <", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearLessThanOrEqualTo(String value) {
            addCriterion("EXPIRY_YEAR <=", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearLike(String value) {
            addCriterion("EXPIRY_YEAR like", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearNotLike(String value) {
            addCriterion("EXPIRY_YEAR not like", value, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearIn(List<String> values) {
            addCriterion("EXPIRY_YEAR in", values, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearNotIn(List<String> values) {
            addCriterion("EXPIRY_YEAR not in", values, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearBetween(String value1, String value2) {
            addCriterion("EXPIRY_YEAR between", value1, value2, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andExpiryYearNotBetween(String value1, String value2) {
            addCriterion("EXPIRY_YEAR not between", value1, value2, "expiryYear");
            return (Criteria) this;
        }

        public Criteria andIssuedDateIsNull() {
            addCriterion("ISSUED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andIssuedDateIsNotNull() {
            addCriterion("ISSUED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andIssuedDateEqualTo(Date value) {
            addCriterion("ISSUED_DATE =", value, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateNotEqualTo(Date value) {
            addCriterion("ISSUED_DATE <>", value, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateGreaterThan(Date value) {
            addCriterion("ISSUED_DATE >", value, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ISSUED_DATE >=", value, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateLessThan(Date value) {
            addCriterion("ISSUED_DATE <", value, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateLessThanOrEqualTo(Date value) {
            addCriterion("ISSUED_DATE <=", value, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateIn(List<Date> values) {
            addCriterion("ISSUED_DATE in", values, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateNotIn(List<Date> values) {
            addCriterion("ISSUED_DATE not in", values, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateBetween(Date value1, Date value2) {
            addCriterion("ISSUED_DATE between", value1, value2, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andIssuedDateNotBetween(Date value1, Date value2) {
            addCriterion("ISSUED_DATE not between", value1, value2, "issuedDate");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("MEMBER_ID is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("MEMBER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(String value) {
            addCriterion("MEMBER_ID =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(String value) {
            addCriterion("MEMBER_ID <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(String value) {
            addCriterion("MEMBER_ID >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(String value) {
            addCriterion("MEMBER_ID <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLike(String value) {
            addCriterion("MEMBER_ID like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotLike(String value) {
            addCriterion("MEMBER_ID not like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<String> values) {
            addCriterion("MEMBER_ID in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<String> values) {
            addCriterion("MEMBER_ID not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(String value1, String value2) {
            addCriterion("MEMBER_ID between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(String value1, String value2) {
            addCriterion("MEMBER_ID not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andModifiedDateIsNull() {
            addCriterion("MODIFIED_DATE is null");
            return (Criteria) this;
        }

        public Criteria andModifiedDateIsNotNull() {
            addCriterion("MODIFIED_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedDateEqualTo(Object value) {
            addCriterion("MODIFIED_DATE =", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateNotEqualTo(Object value) {
            addCriterion("MODIFIED_DATE <>", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateGreaterThan(Object value) {
            addCriterion("MODIFIED_DATE >", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateGreaterThanOrEqualTo(Object value) {
            addCriterion("MODIFIED_DATE >=", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateLessThan(Object value) {
            addCriterion("MODIFIED_DATE <", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateLessThanOrEqualTo(Object value) {
            addCriterion("MODIFIED_DATE <=", value, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateIn(List<Object> values) {
            addCriterion("MODIFIED_DATE in", values, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateNotIn(List<Object> values) {
            addCriterion("MODIFIED_DATE not in", values, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateBetween(Object value1, Object value2) {
            addCriterion("MODIFIED_DATE between", value1, value2, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedDateNotBetween(Object value1, Object value2) {
            addCriterion("MODIFIED_DATE not between", value1, value2, "modifiedDate");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeIsNull() {
            addCriterion("MODIFIED_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeIsNotNull() {
            addCriterion("MODIFIED_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeEqualTo(String value) {
            addCriterion("MODIFIED_TIME =", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeNotEqualTo(String value) {
            addCriterion("MODIFIED_TIME <>", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeGreaterThan(String value) {
            addCriterion("MODIFIED_TIME >", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeGreaterThanOrEqualTo(String value) {
            addCriterion("MODIFIED_TIME >=", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeLessThan(String value) {
            addCriterion("MODIFIED_TIME <", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeLessThanOrEqualTo(String value) {
            addCriterion("MODIFIED_TIME <=", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeLike(String value) {
            addCriterion("MODIFIED_TIME like", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeNotLike(String value) {
            addCriterion("MODIFIED_TIME not like", value, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeIn(List<String> values) {
            addCriterion("MODIFIED_TIME in", values, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeNotIn(List<String> values) {
            addCriterion("MODIFIED_TIME not in", values, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeBetween(String value1, String value2) {
            addCriterion("MODIFIED_TIME between", value1, value2, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andModifiedTimeNotBetween(String value1, String value2) {
            addCriterion("MODIFIED_TIME not between", value1, value2, "modifiedTime");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNull() {
            addCriterion("PAYOR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIsNotNull() {
            addCriterion("PAYOR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPayorCodeEqualTo(String value) {
            addCriterion("PAYOR_CODE =", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotEqualTo(String value) {
            addCriterion("PAYOR_CODE <>", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThan(String value) {
            addCriterion("PAYOR_CODE >", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE >=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThan(String value) {
            addCriterion("PAYOR_CODE <", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLessThanOrEqualTo(String value) {
            addCriterion("PAYOR_CODE <=", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeLike(String value) {
            addCriterion("PAYOR_CODE like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotLike(String value) {
            addCriterion("PAYOR_CODE not like", value, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeIn(List<String> values) {
            addCriterion("PAYOR_CODE in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotIn(List<String> values) {
            addCriterion("PAYOR_CODE not in", values, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPayorCodeNotBetween(String value1, String value2) {
            addCriterion("PAYOR_CODE not between", value1, value2, "payorCode");
            return (Criteria) this;
        }

        public Criteria andPolicyNoIsNull() {
            addCriterion("POLICY_NO is null");
            return (Criteria) this;
        }

        public Criteria andPolicyNoIsNotNull() {
            addCriterion("POLICY_NO is not null");
            return (Criteria) this;
        }

        public Criteria andPolicyNoEqualTo(String value) {
            addCriterion("POLICY_NO =", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotEqualTo(String value) {
            addCriterion("POLICY_NO <>", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoGreaterThan(String value) {
            addCriterion("POLICY_NO >", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoGreaterThanOrEqualTo(String value) {
            addCriterion("POLICY_NO >=", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoLessThan(String value) {
            addCriterion("POLICY_NO <", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoLessThanOrEqualTo(String value) {
            addCriterion("POLICY_NO <=", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoLike(String value) {
            addCriterion("POLICY_NO like", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotLike(String value) {
            addCriterion("POLICY_NO not like", value, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoIn(List<String> values) {
            addCriterion("POLICY_NO in", values, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotIn(List<String> values) {
            addCriterion("POLICY_NO not in", values, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoBetween(String value1, String value2) {
            addCriterion("POLICY_NO between", value1, value2, "policyNo");
            return (Criteria) this;
        }

        public Criteria andPolicyNoNotBetween(String value1, String value2) {
            addCriterion("POLICY_NO not between", value1, value2, "policyNo");
            return (Criteria) this;
        }

        public Criteria andNewIcIsNull() {
            addCriterion("NEW_IC is null");
            return (Criteria) this;
        }

        public Criteria andNewIcIsNotNull() {
            addCriterion("NEW_IC is not null");
            return (Criteria) this;
        }

        public Criteria andNewIcEqualTo(String value) {
            addCriterion("NEW_IC =", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcNotEqualTo(String value) {
            addCriterion("NEW_IC <>", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcGreaterThan(String value) {
            addCriterion("NEW_IC >", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcGreaterThanOrEqualTo(String value) {
            addCriterion("NEW_IC >=", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcLessThan(String value) {
            addCriterion("NEW_IC <", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcLessThanOrEqualTo(String value) {
            addCriterion("NEW_IC <=", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcLike(String value) {
            addCriterion("NEW_IC like", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcNotLike(String value) {
            addCriterion("NEW_IC not like", value, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcIn(List<String> values) {
            addCriterion("NEW_IC in", values, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcNotIn(List<String> values) {
            addCriterion("NEW_IC not in", values, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcBetween(String value1, String value2) {
            addCriterion("NEW_IC between", value1, value2, "newIc");
            return (Criteria) this;
        }

        public Criteria andNewIcNotBetween(String value1, String value2) {
            addCriterion("NEW_IC not between", value1, value2, "newIc");
            return (Criteria) this;
        }

        public Criteria andEmpNameIsNull() {
            addCriterion("EMP_NAME is null");
            return (Criteria) this;
        }

        public Criteria andEmpNameIsNotNull() {
            addCriterion("EMP_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andEmpNameEqualTo(String value) {
            addCriterion("EMP_NAME =", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameNotEqualTo(String value) {
            addCriterion("EMP_NAME <>", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameGreaterThan(String value) {
            addCriterion("EMP_NAME >", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameGreaterThanOrEqualTo(String value) {
            addCriterion("EMP_NAME >=", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameLessThan(String value) {
            addCriterion("EMP_NAME <", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameLessThanOrEqualTo(String value) {
            addCriterion("EMP_NAME <=", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameLike(String value) {
            addCriterion("EMP_NAME like", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameNotLike(String value) {
            addCriterion("EMP_NAME not like", value, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameIn(List<String> values) {
            addCriterion("EMP_NAME in", values, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameNotIn(List<String> values) {
            addCriterion("EMP_NAME not in", values, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameBetween(String value1, String value2) {
            addCriterion("EMP_NAME between", value1, value2, "empName");
            return (Criteria) this;
        }

        public Criteria andEmpNameNotBetween(String value1, String value2) {
            addCriterion("EMP_NAME not between", value1, value2, "empName");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthIsNull() {
            addCriterion("DATE_OF_BIRTH is null");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthIsNotNull() {
            addCriterion("DATE_OF_BIRTH is not null");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthEqualTo(Date value) {
            addCriterion("DATE_OF_BIRTH =", value, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthNotEqualTo(Date value) {
            addCriterion("DATE_OF_BIRTH <>", value, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthGreaterThan(Date value) {
            addCriterion("DATE_OF_BIRTH >", value, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthGreaterThanOrEqualTo(Date value) {
            addCriterion("DATE_OF_BIRTH >=", value, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthLessThan(Date value) {
            addCriterion("DATE_OF_BIRTH <", value, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthLessThanOrEqualTo(Date value) {
            addCriterion("DATE_OF_BIRTH <=", value, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthIn(List<Date> values) {
            addCriterion("DATE_OF_BIRTH in", values, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthNotIn(List<Date> values) {
            addCriterion("DATE_OF_BIRTH not in", values, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthBetween(Date value1, Date value2) {
            addCriterion("DATE_OF_BIRTH between", value1, value2, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andDateOfBirthNotBetween(Date value1, Date value2) {
            addCriterion("DATE_OF_BIRTH not between", value1, value2, "dateOfBirth");
            return (Criteria) this;
        }

        public Criteria andGenderIsNull() {
            addCriterion("GENDER is null");
            return (Criteria) this;
        }

        public Criteria andGenderIsNotNull() {
            addCriterion("GENDER is not null");
            return (Criteria) this;
        }

        public Criteria andGenderEqualTo(String value) {
            addCriterion("GENDER =", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotEqualTo(String value) {
            addCriterion("GENDER <>", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThan(String value) {
            addCriterion("GENDER >", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThanOrEqualTo(String value) {
            addCriterion("GENDER >=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThan(String value) {
            addCriterion("GENDER <", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThanOrEqualTo(String value) {
            addCriterion("GENDER <=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLike(String value) {
            addCriterion("GENDER like", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotLike(String value) {
            addCriterion("GENDER not like", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderIn(List<String> values) {
            addCriterion("GENDER in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotIn(List<String> values) {
            addCriterion("GENDER not in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderBetween(String value1, String value2) {
            addCriterion("GENDER between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotBetween(String value1, String value2) {
            addCriterion("GENDER not between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNull() {
            addCriterion("CORP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIsNotNull() {
            addCriterion("CORP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCorpCodeEqualTo(String value) {
            addCriterion("CORP_CODE =", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotEqualTo(String value) {
            addCriterion("CORP_CODE <>", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThan(String value) {
            addCriterion("CORP_CODE >", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CORP_CODE >=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThan(String value) {
            addCriterion("CORP_CODE <", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLessThanOrEqualTo(String value) {
            addCriterion("CORP_CODE <=", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeLike(String value) {
            addCriterion("CORP_CODE like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotLike(String value) {
            addCriterion("CORP_CODE not like", value, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeIn(List<String> values) {
            addCriterion("CORP_CODE in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotIn(List<String> values) {
            addCriterion("CORP_CODE not in", values, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeBetween(String value1, String value2) {
            addCriterion("CORP_CODE between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andCorpCodeNotBetween(String value1, String value2) {
            addCriterion("CORP_CODE not between", value1, value2, "corpCode");
            return (Criteria) this;
        }

        public Criteria andChipLastupdIsNull() {
            addCriterion("CHIP_LASTUPD is null");
            return (Criteria) this;
        }

        public Criteria andChipLastupdIsNotNull() {
            addCriterion("CHIP_LASTUPD is not null");
            return (Criteria) this;
        }

        public Criteria andChipLastupdEqualTo(Date value) {
            addCriterion("CHIP_LASTUPD =", value, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdNotEqualTo(Date value) {
            addCriterion("CHIP_LASTUPD <>", value, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdGreaterThan(Date value) {
            addCriterion("CHIP_LASTUPD >", value, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdGreaterThanOrEqualTo(Date value) {
            addCriterion("CHIP_LASTUPD >=", value, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdLessThan(Date value) {
            addCriterion("CHIP_LASTUPD <", value, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdLessThanOrEqualTo(Date value) {
            addCriterion("CHIP_LASTUPD <=", value, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdIn(List<Date> values) {
            addCriterion("CHIP_LASTUPD in", values, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdNotIn(List<Date> values) {
            addCriterion("CHIP_LASTUPD not in", values, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdBetween(Date value1, Date value2) {
            addCriterion("CHIP_LASTUPD between", value1, value2, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andChipLastupdNotBetween(Date value1, Date value2) {
            addCriterion("CHIP_LASTUPD not between", value1, value2, "chipLastupd");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIsNull() {
            addCriterion("PLAN_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIsNotNull() {
            addCriterion("PLAN_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPlanCodeEqualTo(String value) {
            addCriterion("PLAN_CODE =", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotEqualTo(String value) {
            addCriterion("PLAN_CODE <>", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeGreaterThan(String value) {
            addCriterion("PLAN_CODE >", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PLAN_CODE >=", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLessThan(String value) {
            addCriterion("PLAN_CODE <", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLessThanOrEqualTo(String value) {
            addCriterion("PLAN_CODE <=", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeLike(String value) {
            addCriterion("PLAN_CODE like", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotLike(String value) {
            addCriterion("PLAN_CODE not like", value, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeIn(List<String> values) {
            addCriterion("PLAN_CODE in", values, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotIn(List<String> values) {
            addCriterion("PLAN_CODE not in", values, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeBetween(String value1, String value2) {
            addCriterion("PLAN_CODE between", value1, value2, "planCode");
            return (Criteria) this;
        }

        public Criteria andPlanCodeNotBetween(String value1, String value2) {
            addCriterion("PLAN_CODE not between", value1, value2, "planCode");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNull() {
            addCriterion("ENGLISH_NAME is null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNotNull() {
            addCriterion("ENGLISH_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameEqualTo(String value) {
            addCriterion("ENGLISH_NAME =", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotEqualTo(String value) {
            addCriterion("ENGLISH_NAME <>", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThan(String value) {
            addCriterion("ENGLISH_NAME >", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThanOrEqualTo(String value) {
            addCriterion("ENGLISH_NAME >=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThan(String value) {
            addCriterion("ENGLISH_NAME <", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThanOrEqualTo(String value) {
            addCriterion("ENGLISH_NAME <=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLike(String value) {
            addCriterion("ENGLISH_NAME like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotLike(String value) {
            addCriterion("ENGLISH_NAME not like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIn(List<String> values) {
            addCriterion("ENGLISH_NAME in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotIn(List<String> values) {
            addCriterion("ENGLISH_NAME not in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameBetween(String value1, String value2) {
            addCriterion("ENGLISH_NAME between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotBetween(String value1, String value2) {
            addCriterion("ENGLISH_NAME not between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andCardTypeIsNull() {
            addCriterion("CARD_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCardTypeIsNotNull() {
            addCriterion("CARD_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCardTypeEqualTo(String value) {
            addCriterion("CARD_TYPE =", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotEqualTo(String value) {
            addCriterion("CARD_TYPE <>", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeGreaterThan(String value) {
            addCriterion("CARD_TYPE >", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_TYPE >=", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLessThan(String value) {
            addCriterion("CARD_TYPE <", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLessThanOrEqualTo(String value) {
            addCriterion("CARD_TYPE <=", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLike(String value) {
            addCriterion("CARD_TYPE like", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotLike(String value) {
            addCriterion("CARD_TYPE not like", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeIn(List<String> values) {
            addCriterion("CARD_TYPE in", values, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotIn(List<String> values) {
            addCriterion("CARD_TYPE not in", values, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeBetween(String value1, String value2) {
            addCriterion("CARD_TYPE between", value1, value2, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotBetween(String value1, String value2) {
            addCriterion("CARD_TYPE not between", value1, value2, "cardType");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoIsNull() {
            addCriterion("MASTER_POLICY_NO is null");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoIsNotNull() {
            addCriterion("MASTER_POLICY_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoEqualTo(String value) {
            addCriterion("MASTER_POLICY_NO =", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoNotEqualTo(String value) {
            addCriterion("MASTER_POLICY_NO <>", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoGreaterThan(String value) {
            addCriterion("MASTER_POLICY_NO >", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoGreaterThanOrEqualTo(String value) {
            addCriterion("MASTER_POLICY_NO >=", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoLessThan(String value) {
            addCriterion("MASTER_POLICY_NO <", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoLessThanOrEqualTo(String value) {
            addCriterion("MASTER_POLICY_NO <=", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoLike(String value) {
            addCriterion("MASTER_POLICY_NO like", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoNotLike(String value) {
            addCriterion("MASTER_POLICY_NO not like", value, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoIn(List<String> values) {
            addCriterion("MASTER_POLICY_NO in", values, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoNotIn(List<String> values) {
            addCriterion("MASTER_POLICY_NO not in", values, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoBetween(String value1, String value2) {
            addCriterion("MASTER_POLICY_NO between", value1, value2, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMasterPolicyNoNotBetween(String value1, String value2) {
            addCriterion("MASTER_POLICY_NO not between", value1, value2, "masterPolicyNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoIsNull() {
            addCriterion("MEMBER_CONTROL_NO is null");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoIsNotNull() {
            addCriterion("MEMBER_CONTROL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO =", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO <>", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoGreaterThan(String value) {
            addCriterion("MEMBER_CONTROL_NO >", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO >=", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoLessThan(String value) {
            addCriterion("MEMBER_CONTROL_NO <", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_CONTROL_NO <=", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoLike(String value) {
            addCriterion("MEMBER_CONTROL_NO like", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotLike(String value) {
            addCriterion("MEMBER_CONTROL_NO not like", value, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoIn(List<String> values) {
            addCriterion("MEMBER_CONTROL_NO in", values, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotIn(List<String> values) {
            addCriterion("MEMBER_CONTROL_NO not in", values, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoBetween(String value1, String value2) {
            addCriterion("MEMBER_CONTROL_NO between", value1, value2, "memberControlNo");
            return (Criteria) this;
        }

        public Criteria andMemberControlNoNotBetween(String value1, String value2) {
            addCriterion("MEMBER_CONTROL_NO not between", value1, value2, "memberControlNo");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}